Date Fields

Report Criteria Expressions based on date fields offer extensive options to dynamically generate timely report data. If a value has already been defined for a field, it will be displayed.

For all date fields, you can specify that dates should be within, before, after, or between certain dates. The options in the field that define the relationship between the field value and the specified date or date range are listed below:

• Is within

• Is not within

• Is

• Is between

• Is not between

• Is after

• Is before

• Is not

The first two options allow you to select from a series of date ranges to complete your criteria, such as current year, quarter to date, last 6 months, or last/next year. These options also allow you to specify that the value must exist (Value Exists) or should be blank/empty (Value does not Exist). For a more complete description of the available options, see Date Range Prompts.

The remaining options in the field allow you to enter a specific date or dates for a date range. No field choices are available. For instructions on formatting report criteria for dates, see Defining Expressions for Date Fields.